home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Belgian Amiga Club - ADF Collection
/
BS1 part 34.zip
/
BS1 part 34
/
Maxiplan III 3.5.adf
/
MP3
/
New.Macros
< prev
next >
Wrap
Text File
|
1990-01-08
|
4KB
|
118 lines
All about MaxiPlan-III new macros
As always, as we finished the features for a new release we found
that it would be nice if these features had some macro support. In
MaxiPlan-III the new macros fall into three categories: ARexx support,
DataView(tm) and Outline mode.
ARexx support
=============
Macro: STRING.VALUE
Usage: This macro is ONLY valid when it comes in from the ARexx port.
It returns the "string" value of the currently selected cell.
This means that it returns the string for label cells, the
formatted string (including currency symbols, commas, percent
symbols, etc.) for value cells and the actual Formula as a text
string for cells containing formulas.
Note: You can retrieve the value (as a string) for formula cells
by using the CONTENTS macro.
Using the STRING.VALUE macro you can extract the entire contents
of a worksheet as strings. You could then use this information
to analyze the worksheet or convert it for input to a foreign
system (such as a SYLK file).
DataView(tm) Support
====================
You can record a DataView(tm) session and all your actions will be
saved using the macros shown below. This, of course, means that you
can create macro programs that work when DataView is active.
This is particularly important since we enhanced the functionality
of DataView by allowing you to write macros that are called when you
press the F-keys. Normally, in DataView mode the function keys are
ignored. However, each time you press a function key, MaxiPlan-III
searches for a macro (on the current macro sheet) named DATAVIEW.Fxx
(where xx is the number of the F-key, examples: DATAVIEW.F1,
DATAVIEW.F12, etc.) The normal F-keys are F1 through F10 and if
you hold down the SHIFT key when you press an F-key it is numbered
F11 through F20.
In addition, (as noted in the More.DataView file), if the upper
left cell in the data range (the first category (field) name cell)
contains a cell note then the first line of this cell note is
shown at the bottom of the DataView window. This is the place
to put the meaning of your function keys! Also, don't forget the
MESSAGE macro which can be used to give help.
DATAVIEW macros are described on the next page!
DATAVIEW macros:
================
Macro: ENTER.DATAVIEW
Usage: Puts MaxiPlan-III into DataView mode. You should select a database
before using this macro. If you do not have a database selected
the name selector will prompt the user for a database selection.
Macro: EXIT.DATAVIEW
Usage: Puts MaxiPlan-III back in to Norm view.
Macro: DATAVIEW.FIRST
Usage: Moves to first record in the data range.
Macro: DATAVIEW.NEXT
Usage: Moves to the next record in the data range.
Macro: DATAVIEW.PREV
Usage: Moves to the previous record in the range.
Macro: DATAVIEW.LAST
Usage: Moves to the last record in the data range.
Macro: ADD.RECORD
Usage: Adds new record on the of data range. Positions current record
at new area.
OUTLINE mode macros:
====================
Macro: OUTLINE.LEVEL(n)
Usage: Sets the outline level of the currently selected range to 'n'.
Macro: OUTLINE.DISPLAY(n)
Usage: Sets the outline display level to 'n'. Redraws screen.
This macro is most useful when creating a variety of reports
at different outline display levels.